In [1]:
In [2]:
In [3]:
Province/State Country/Region Lat Long 1/22/20 1/23/20 1/24/20 1/25/20 1/26/20 1/27/20 ... 3/12/21 3/13/21 3/14/21 3/15/21 3/16/21 3/17/21 3/18/21 3/19/21 3/20/21 3/21/21
0 NaN Afghanistan 33.939110 67.709953 0 0 0 0 0 0 ... 55959 55959 55985 55985 55995 56016 56044 56069 56093 56103
1 NaN Albania 41.153300 20.168300 0 0 0 0 0 0 ... 116123 116821 117474 118017 118492 118938 119528 120022 120541 121200
2 NaN Algeria 28.033900 1.659600 0 0 0 0 0 0 ... 115008 115143 115265 115410 115540 115688 115842 115970 116066 116157
3 NaN Andorra 42.506300 1.521800 0 0 0 0 0 0 ... 11199 11228 11266 11289 11319 11360 11393 11431 11481 11517
4 NaN Angola -11.202700 17.873900 0 0 0 0 0 0 ... 21265 21323 21380 21407 21446 21489 21558 21642 21696 21733
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
269 NaN Vietnam 14.058324 108.277199 0 2 2 2 2 2 ... 2550 2553 2554 2557 2560 2567 2570 2571 2572 2572
270 NaN West Bank and Gaza 31.952200 35.233200 0 0 0 0 0 0 ... 205652 207436 209304 211602 213791 215984 218061 219912 221391 223638
271 NaN Yemen 15.552727 48.516388 0 0 0 0 0 0 ... 2729 2771 2836 2908 2969 3037 3126 3217 3278 3418
272 NaN Zambia -13.133897 27.849332 0 0 0 0 0 0 ... 84240 84474 84797 84950 85240 85502 85889 86059 86273 86449
273 NaN Zimbabwe -19.015438 29.154857 0 0 0 0 0 0 ... 36423 36471 36484 36504 36535 36552 36611 36652 36662 36665

274 rows × 429 columns

In [4]:
Out[4]:
array([nan, 'Australian Capital Territory', 'New South Wales',
       'Northern Territory', 'Queensland', 'South Australia', 'Tasmania',
       'Victoria', 'Western Australia', 'Alberta', 'British Columbia',
       'Diamond Princess', 'Grand Princess', 'Manitoba', 'New Brunswick',
       'Newfoundland and Labrador', 'Northwest Territories',
       'Nova Scotia', 'Nunavut', 'Ontario', 'Prince Edward Island',
       'Quebec', 'Repatriated Travellers', 'Saskatchewan', 'Yukon',
       'Anhui', 'Beijing', 'Chongqing', 'Fujian', 'Gansu', 'Guangdong',
       'Guangxi', 'Guizhou', 'Hainan', 'Hebei', 'Heilongjiang', 'Henan',
       'Hong Kong', 'Hubei', 'Hunan', 'Inner Mongolia', 'Jiangsu',
       'Jiangxi', 'Jilin', 'Liaoning', 'Macau', 'Ningxia', 'Qinghai',
       'Shaanxi', 'Shandong', 'Shanghai', 'Shanxi', 'Sichuan', 'Tianjin',
       'Tibet', 'Xinjiang', 'Yunnan', 'Zhejiang', 'Faroe Islands',
       'Greenland', 'French Guiana', 'French Polynesia', 'Guadeloupe',
       'Martinique', 'Mayotte', 'New Caledonia', 'Reunion',
       'Saint Barthelemy', 'Saint Pierre and Miquelon', 'St Martin',
       'Wallis and Futuna', 'Aruba', 'Bonaire, Sint Eustatius and Saba',
       'Curacao', 'Sint Maarten', 'Anguilla', 'Bermuda',
       'British Virgin Islands', 'Cayman Islands', 'Channel Islands',
       'Falkland Islands (Malvinas)', 'Gibraltar', 'Isle of Man',
       'Montserrat', 'Saint Helena, Ascension and Tristan da Cunha',
       'Turks and Caicos Islands'], dtype=object)
In [5]:
In [6]:
Out[6]:
1/22/20          557
1/23/20          655
1/24/20          941
1/25/20         1433
1/26/20         2118
             ...    
3/17/21    121236071
3/18/21    121789383
3/19/21    122315656
3/20/21    122813796
3/21/21    123207571
Length: 425, dtype: int64
In [7]:
Out[7]:
12/22/20
Country
US 18351480
India 10099066
Brazil 7318821
Russia 2878382
France 2547577
United Kingdom 2116612
Turkey 2062960
Italy 1977370
Spain 1829903
Germany 1570371
In [ ]:
In [8]:
In [9]:
Out[9]:
1/22/20 1/23/20 1/24/20 1/25/20 1/26/20 1/27/20 1/28/20 1/29/20 1/30/20 1/31/20 ... 3/12/21 3/13/21 3/14/21 3/15/21 3/16/21 3/17/21 3/18/21 3/19/21 3/20/21 3/21/21
Country
US 1 1 2 2 5 5 5 6 6 8 ... 29347338 29400553 29438775 29495424 29549235 29608206 29668587 29730000 29785285 29818930
Brazil 0 0 0 0 0 0 0 0 0 0 ... 11363380 11439558 11483370 11519609 11603535 11693838 11780820 11871390 11950459 11998233
India 0 0 0 0 0 0 0 0 1 1 ... 11333728 11359048 11385339 11409831 11438734 11474605 11514331 11555284 11599130 11646081
Russia 0 0 0 0 0 0 0 0 0 2 ... 4321588 4331396 4341381 4350728 4360033 4368943 4378656 4388268 4397816 4407031
United Kingdom 0 0 0 0 0 0 0 0 0 2 ... 4261398 4267015 4271710 4276840 4282203 4287996 4294328 4299200 4304839 4310195
France 0 0 2 3 3 3 4 5 5 5 ... 4075735 4105527 4131874 4138345 4168411 4206912 4241973 4242145 4277183 4277786
Italy 0 0 0 0 0 0 0 0 0 2 ... 3175807 3201838 3223142 3238394 3258770 3281810 3306711 3332418 3356331 3376376
Spain 0 0 0 0 0 0 0 0 0 0 ... 3183704 3183704 3183704 3195062 3200024 3206116 3212332 3212332 3212332 3212332
Turkey 0 0 0 0 0 0 0 0 0 0 ... 2850930 2866012 2879390 2894893 2911642 2930554 2950603 2971633 2992694 3013122
Germany 0 0 0 0 0 1 4 4 4 5 ... 2559296 2569864 2578842 2585385 2603064 2610769 2639258 2654734 2669233 2670001

10 rows × 425 columns

In [34]:
In [11]:
Out[11]:
Country US Brazil India Russia United Kingdom France Italy Spain Turkey Germany
1/22/20 1 0 0 0 0 0 0 0 0 0
1/23/20 1 0 0 0 0 0 0 0 0 0
1/24/20 2 0 0 0 0 2 0 0 0 0
1/25/20 2 0 0 0 0 3 0 0 0 0
1/26/20 5 0 0 0 0 3 0 0 0 0
... ... ... ... ... ... ... ... ... ... ...
3/17/21 29608206 11693838 11474605 4368943 4287996 4206912 3281810 3206116 2930554 2610769
3/18/21 29668587 11780820 11514331 4378656 4294328 4241973 3306711 3212332 2950603 2639258
3/19/21 29730000 11871390 11555284 4388268 4299200 4242145 3332418 3212332 2971633 2654734
3/20/21 29785285 11950459 11599130 4397816 4304839 4277183 3356331 3212332 2992694 2669233
3/21/21 29818930 11998233 11646081 4407031 4310195 4277786 3376376 3212332 3013122 2670001

425 rows × 10 columns

In [12]:
Out[12]:
<AxesSubplot:>
In [35]:
In [14]:
In [15]:
1/22/201/31/202/9/202/18/202/27/203/7/203/16/203/25/204/3/204/12/204/21/204/30/205/9/205/18/205/27/206/5/206/14/206/23/207/2/207/11/207/20/207/29/208/7/208/16/208/25/209/3/209/12/209/21/209/30/2010/9/2010/18/2010/27/2011/5/2011/14/2011/23/2012/2/2012/11/2012/20/2012/29/201/7/211/16/211/25/212/3/212/12/212/21/213/2/213/11/213/20/2105M10M15M20M25M30MExport to plot.ly »
USBrazilIndiaRussiaUnited KingdomFranceItalySpainTurkeyGermany
In [16]:
Out[16]:
Lat Long 1/22/20 1/23/20 1/24/20 1/25/20 1/26/20 1/27/20 1/28/20 1/29/20 ... 3/12/21 3/13/21 3/14/21 3/15/21 3/16/21 3/17/21 3/18/21 3/19/21 3/20/21 3/21/21
Country
US 40.000000 -100.000000 0 0 0 0 0 0 0 0 ... 533050 534780 535356 536098 537263 538436 540047 541144 541927 542359
Brazil -14.235000 -51.925300 0 0 0 0 0 0 0 0 ... 275105 277102 278229 279286 282127 284775 287499 290314 292752 294042
Mexico 23.634500 -102.552800 0 0 0 0 0 0 0 0 ... 193851 194490 194710 194944 195119 195908 196606 197219 197827 198036
India 20.593684 78.962880 0 0 0 0 0 0 0 0 ... 158446 158607 158725 158856 159044 159216 159370 159558 159755 159967
United Kingdom 262.083198 -497.280566 0 0 0 0 0 0 0 0 ... 125579 125701 125753 125817 125927 126068 126163 126263 126359 126393
Italy 41.871940 12.567380 0 0 0 0 0 0 0 0 ... 101564 101881 102145 102499 103001 103432 103855 104241 104642 104942
Russia 61.524010 105.318756 0 0 0 0 0 0 0 0 ... 89701 90169 90558 90958 91395 91815 92266 92704 93090 93457
France 77.103595 -118.075614 0 0 0 0 0 0 0 0 ... 90207 90376 90583 90924 91324 91411 91833 91833 92119 92119
Germany 51.165691 10.451526 0 0 0 0 0 0 0 0 ... 73348 73369 73463 73701 73952 74043 74402 74608 74706 74756
Spain 40.463667 -3.749220 0 0 0 0 0 0 0 0 ... 72258 72258 72258 72424 72565 72793 72910 72910 72910 72910

10 rows × 427 columns

In [17]:
Lat1/29/202/7/202/16/202/25/203/5/203/14/203/23/204/1/204/10/204/19/204/28/205/7/205/16/205/25/206/3/206/12/206/21/206/30/207/9/207/18/207/27/208/5/208/14/208/23/209/1/209/10/209/19/209/28/2010/7/2010/16/2010/25/2011/3/2011/12/2011/21/2011/30/2012/9/2012/18/2012/27/201/5/211/14/211/23/212/1/212/10/212/19/212/28/213/9/213/18/210100k200k300k400k500kExport to plot.ly »
USBrazilMexicoIndiaUnited KingdomItalyRussiaFranceGermanySpain
In [18]:
Out[18]:
Lat Long 1/22/20 1/23/20 1/24/20 1/25/20 1/26/20 1/27/20 1/28/20 1/29/20 ... 3/12/21 3/13/21 3/14/21 3/15/21 3/16/21 3/17/21 3/18/21 3/19/21 3/20/21 3/21/21
Country
India 20.593684 78.962880 0 0 0 0 0 0 0 0 ... 10973260 10989897 11007352 11027543 11045284 11063025 11083679 11107332 11130288 11151468
Brazil -14.235000 -51.925300 0 0 0 0 0 0 0 0 ... 10041024 10084820 10113487 10195598 10261154 10326375 10383496 10435864 10476123 10509457
Russia 61.524010 105.318756 0 0 0 0 0 0 0 0 ... 3928114 3940744 3949891 3958300 3968826 3979436 3991385 4003682 4014770 4023460
Turkey 38.963700 35.243300 0 0 0 0 0 0 0 0 ... 2670273 2685560 2701076 2716969 2734862 2752023 2770638 2788757 2807572 2825187
Italy 41.871940 12.567380 0 0 0 0 0 0 0 0 ... 2564926 2579896 2589731 2605538 2619654 2639370 2655346 2671638 2686236 2699762
Germany 51.165691 10.451526 0 0 0 0 0 0 0 0 ... 2356590 2357374 2368995 2377584 2387232 2387743 2405600 2413584 2419292 2426700
Colombia 4.570900 -74.297300 0 0 0 0 0 0 0 0 ... 2195569 2199508 2202580 2206210 2209224 2212512 2216945 2221642 2225725 2230192
Argentina -38.416100 -63.616700 0 0 0 0 0 0 0 0 ... 1974866 1981157 1986903 1993215 1998594 2003121 2009877 2016729 2023664 2030153
Mexico 23.634500 -102.552800 0 0 0 0 0 0 0 0 ... 1696739 1701216 1705743 1711931 1716135 1720430 1724794 1729269 1733089 1736159
Poland 51.919400 19.145100 0 0 0 0 0 0 0 0 ... 1530484 1546151 1560227 1574455 1587164 1593165 1603832 1620272 1640050 1656827

10 rows × 427 columns

In [19]:
Lat1/29/202/7/202/16/202/25/203/5/203/14/203/23/204/1/204/10/204/19/204/28/205/7/205/16/205/25/206/3/206/12/206/21/206/30/207/9/207/18/207/27/208/5/208/14/208/23/209/1/209/10/209/19/209/28/2010/7/2010/16/2010/25/2011/3/2011/12/2011/21/2011/30/2012/9/2012/18/2012/27/201/5/211/14/211/23/212/1/212/10/212/19/212/28/213/9/213/18/2102M4M6M8M10MExport to plot.ly »
IndiaBrazilRussiaTurkeyItalyGermanyColombiaArgentinaMexicoPoland
In [20]:
In [21]:
1/22/201/30/202/7/202/15/202/23/203/2/203/10/203/18/203/26/204/3/204/11/204/19/204/27/205/5/205/13/205/21/205/29/206/6/206/14/206/22/206/30/207/8/207/16/207/24/208/1/208/9/208/17/208/25/209/2/209/10/209/18/209/26/2010/4/2010/12/2010/20/2010/28/2011/5/2011/13/2011/21/2011/29/2012/7/2012/15/2012/23/2012/31/201/8/211/16/211/24/212/1/212/9/212/17/212/25/213/5/213/13/213/21/21050k100k150k200k250k300kExport to plot.ly »
Daily confirmed cases in US

Merging the three datasets

In [22]:
In [23]:
Out[23]:
Confirmed Deaths Recovered
1/22/20 557 17 30
1/23/20 655 18 32
1/24/20 941 26 39
1/25/20 1433 42 42
1/26/20 2118 56 56
... ... ... ...
3/17/21 121236071 2680865 68716840
3/18/21 121789383 2691384 68985877
3/19/21 122315656 2701446 69264939
3/20/21 122813796 2709640 69523087
3/21/21 123207571 2715295 69803099

425 rows × 3 columns

In [36]:
In [25]:
1/22/201/31/202/9/202/18/202/27/203/7/203/16/203/25/204/3/204/12/204/21/204/30/205/9/205/18/205/27/206/5/206/14/206/23/207/2/207/11/207/20/207/29/208/7/208/16/208/25/209/3/209/12/209/21/209/30/2010/9/2010/18/2010/27/2011/5/2011/14/2011/23/2012/2/2012/11/2012/20/2012/29/201/7/211/16/211/25/212/3/212/12/212/21/213/2/213/11/213/20/21020M40M60M80M100M120MExport to plot.ly »
ConfirmedDeathsRecoveredActiveFatality RateRecovery Rate
In [26]:
1/22/201/30/202/7/202/15/202/23/203/2/203/10/203/18/203/26/204/3/204/11/204/19/204/27/205/5/205/13/205/21/205/29/206/6/206/14/206/22/206/30/207/8/207/16/207/24/208/1/208/9/208/17/208/25/209/2/209/10/209/18/209/26/2010/4/2010/12/2010/20/2010/28/2011/5/2011/13/2011/21/2011/29/2012/7/2012/15/2012/23/2012/31/201/8/211/16/211/24/212/1/212/9/212/17/212/25/213/5/213/13/213/21/21234567Export to plot.ly »
World Covid Fatality Rate
In [27]:
1/22/201/30/202/7/202/15/202/23/203/2/203/10/203/18/203/26/204/3/204/11/204/19/204/27/205/5/205/13/205/21/205/29/206/6/206/14/206/22/206/30/207/8/207/16/207/24/208/1/208/9/208/17/208/25/209/2/209/10/209/18/209/26/2010/4/2010/12/2010/20/2010/28/2011/5/2011/13/2011/21/2011/29/2012/7/2012/15/2012/23/2012/31/201/8/211/16/211/24/212/1/212/9/212/17/212/25/213/5/213/13/213/21/21010203040506070Export to plot.ly »
World Covid Recovering Rate

Display Covid19 Cases on World Map

In [38]:
In [30]:
In [ ]:
In [32]:
In [33]:
Out[33]:
Make this Notebook Trusted to load map: File -> Trust Notebook
In [ ]:
In [ ]:
In [ ]: